Tables are database objects that contain all the data in a database. A table definition is a collection of columns. In tables, data is organized in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field within the record.
Just simply click to open an object pane for Table.
By using the object pane toolbar below, you can create new, edit, open and
delete the selected table.
Create Table
To create a new table
- Select anywhere on the object pane.
- Click the
from the object pane toolbar.
or - Control-click and select New Table to choose the popup menu.
- Edit table properties and fields on the appropriate tabs of the Table Designer.
Hint: To create new table you can also control-click the Tables node of the navigation pane and select the New Table from the popup menu.
To create a new table with the same properties as one of the existing tables has (using popup menu)
Apply to: current database {same connection}
- Select the table(s) for copying in the navigation pane/object pane.
- Control-click and select the Duplicate Table -> Structure + Data/Structure Only from the popup menu.
- The newly created table(s) will be named as "tablename_copy".
To create a new table with the same properties as one of the existing tables has (using drag and drop method)
Apply to: current database {same connection}
- Select the table(s) for copying in the navigation pane/object pane.
- Click and drag the chosen table(s) to the target location.
- Select one of the following options:
- Copy here (Structure only)
- Copy here (Structure and Data)
- Cancel
- The newly created table(s) will be named as "tabletname_copy"
Apply to: different database {same connection} different database {different connection (same or cross server type)} (Data Transfer tool will be activated)
- Select the table(s) for copying in the object pane.
- Drag and drop the chosen table(s) to the target database.
- Select one of the following options:
- Copy here (Structure only)
- Copy here (Structure and Data)
- Cancel
To create a new table with modification as one of the existing tables
- Select the table for modifying in the navigation pane/object pane.
- Control-click and select the Design
Table from the popup menu.
or - Click the
from the object pane toolbar.
- Modify table properties and fields on the appropriate tabs of the Table Designer.
- Click
Save As.
To edit the existing table (manage its fields, indexes, foreign keys and triggers etc)
- Select the table for editing in the navigation pane/object pane.
- Control-click and select the Design
Table from the popup menu.
or - Click the
from the object pane toolbar.
- Edit table properties and fields on the appropriate tabs of the Table Designer.
To change the name of the table
- Select the table for editing in the navigation pane/object pane.
- Control-click and select the Rename from the popup menu.
Open Table (manage table data)
To open a table
- Select the table for opening in the navigation pane/object pane.
- Control-click and select the Open Table
from the popup menu or simply double-click the table.
or - Click the Open from the object
pane toolbar.
Note: This option is only applied if you do wish Navicat loads all your images while opening the table. To open the graphical table with faster performance, use Open Table (Quick) below.
To open a table with graphical fields
- Select the table for opening in the navigation pane/object pane.
- Control-click and select the Open Table
(Quick) from the popup menu.
Note: Faster performance for opening the graphical table, as BLOB fields (images) will not be loaded until you click on the cell.
Empty Table
To empty a table
- Select the table in the navigation pane/object pane.
- Control-click the selected table and choose Empty Table from the popup menu.
Note: This option is only applied when you wish to clear all the existing records without resetting the auto-increment value. To reset the auto-increment value while emptying your table, use Truncate Table below.
Truncate Table
To truncate a table
- Select the table in the navigation pane/object pane.
- Control-click the selected table and choose Truncate Table from the popup menu.
Delete Table
To delete a table
- Select the table for deleting in the navigation pane/object pane.
- Control-click and select the Delete
Table from the popup menu.
or - Click the
from the object pane toolbar.
- Confirm deleting in the dialog window.
Table Shortcut
To create a table shortcut
- Select the table in the navigation pane/object pane.
- Drag the table out as a shortcut.
Achieve Table Information
To achieve a table information
- Select the table in the navigation pane/object pane.
- Choose View -> Object Information in the main menu.
or - Click the
from the object pane toolbar.